Edinburgh’s road network

Edinburgh’s implementation zones

Edinburgh’s control zones

Time series analysis

Mapping accidents with roads: 2013

##                    LAYER Accident_Index
## 1 20mph existing streets             49
## 2    20mph local streets             82
## 3     20mph main streets            206
## 4                  30mph            109
## 5                  40mph             60
## 6        50, 60 or 70mph              1
## 7        Part time 20mph              1
## 8            Trunk roads              2
##   Speed_limit Accident_Index
## 1          20             25
## 2          30            437
## 3          40             48
##                    LAYER Accident_Index
## 1 20mph existing streets             48
## 2    20mph local streets             72
## 3     20mph main streets            182
## 4                  30mph             98
## 5                  40mph             43
## 6        50, 60 or 70mph              1
## 7        Part time 20mph              1
## 8            Trunk roads              2
##   Speed_limit Accident_Index
## 1          20             25
## 2          30            387
## 3          40             35

Mapping accidents with roads: 2014

##                    LAYER Accident_Index
## 1 20mph existing streets            172
## 2    20mph local streets            172
## 3     20mph main streets            428
## 4                  30mph            309
## 5                  40mph             81
## 6        50, 60 or 70mph             22
## 7        Part time 20mph             11
## 8            Trunk roads              5
##   Speed_limit Accident_Index
## 1          20             43
## 2          30           1075
## 3          40             82

Mapping accidents with roads: 2015

##                    LAYER Accident_Index
## 1 20mph existing streets            121
## 2    20mph local streets            188
## 3     20mph main streets            357
## 4                  30mph            296
## 5                  40mph            100
## 6        50, 60 or 70mph             17
## 7        Part time 20mph              6
## 8            Trunk roads              7
##   Speed_limit Accident_Index
## 1          20             36
## 2          30            951
## 3          40            105

Mapping accidents with roads: 2016

##                    LAYER Accident_Index
## 1 20mph existing streets             56
## 2    20mph local streets             60
## 3     20mph main streets             26
## 4                  30mph             32
## 5                  40mph             19
##   Speed_limit Accident_Index
## 1          20              8
## 2          30            164
## 3          40             21

Mapping accidents with roads: 2018

##                    LAYER Accident_Index
## 1 20mph existing streets             70
## 2    20mph local streets             96
## 3     20mph main streets            202
## 4                  30mph            172
## 5                  40mph             70
## 6        50, 60 or 70mph              7
## 7        Part time 20mph             13
## 8            Trunk roads              3
##   Speed_limit Accident_Index
## 1          20            315
## 2          30            239
## 3          40             79

Mapping accidents with roads: 2019

##                    LAYER Accident_Index
## 1 20mph existing streets             31
## 2    20mph local streets             52
## 3     20mph main streets             87
## 4                  30mph             77
## 5                  40mph             24
## 6        50, 60 or 70mph              2
## 7        Part time 20mph              1
## 8            Trunk roads              1
##   Speed_limit Accident_Index
## 1          20            153
## 2          30             97
## 3          40             25

Count pre 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets            398
## 2    20mph local streets            502
## 3     20mph main streets           1017
## 4                  30mph            746
## 5                  40mph            260
## 6        50, 60 or 70mph             40
## 7        Part time 20mph             18
## 8            Trunk roads             14
##   Speed_limit Accident_Index
## 1          20            112
## 2          30           2627
## 3          40            256

Count post 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets            101
## 2    20mph local streets            148
## 3     20mph main streets            289
## 4                  30mph            249
## 5                  40mph             94
## 6        50, 60 or 70mph              9
## 7        Part time 20mph             14
## 8            Trunk roads              4
##   Speed_limit Accident_Index
## 1          20            468
## 2          30            336
## 3          40            104

Output column: Layer

##     ID Speed_limit               LAYER
## 1 3815          20  20mph main streets
## 2 3816          20 20mph local streets
## 3 3818          40 20mph local streets
## 4 3819          20               30mph
## 5 3817          40               40mph
## 6 3820          30               30mph

Table: Average annual road traffic collision rates in the city of Edinburgh (GIS)

Table 1: Average annual road traffic collision rates in the city of Edinburgh (GIS)
Type collisions pre-20mph collisions post-20mph rate pre-20mph rate post-20mph diff in rates Perc.diff.rates
Streets at 30mph 746 249 0.41 0.28 0.13 31.71
Streets at 20mph 398 101 0.22 0.11 0.11 50.00
Streets at 30mph changed to 20mph 1519 437 0.83 0.50 0.33 39.76
Streets at 40mph 260 94 0.14 0.11 0.03 21.43
All streets 1841 881 1.00 1.00 0.00 0.00

Table: Average annual road traffic collision rates in the city of Edinburgh (Stats19)

Table 2: Average annual road traffic collision rates in the city of Edinburgh (Stats19)
Type collisions pre-20mph collisions post-20mph rate pre-20mph rate post-20mph diff in rates Perc.diff.rates
Streets at 20mph 112 468 0.04 0.52 -0.48 -12.00
Streets at 30mph 2627 336 0.88 0.37 0.51 0.58
Streets at 40mph 256 104 0.09 0.11 -0.02 -0.22
All streets 2995 908 1.00 1.00 0.00 0.00

Effect estimate (GIS)

Effect estimate(GIS)
Tax year 2013/14 2014/15 2015/16 2018/19
Annual number of collisions 1203 1103 689 908
Effect estimate 31.6

Effect estimate (Stats19)

Effect estimate(Stats19)
Tax year 2013/14 2014/15 2015/16 2018/19
Annual number of collisions 1175 1074 674 881
Effect estimate 31.87

Mapping accidents with implementation zones: 2013

##   ImplementationZone Accident_Index
## 1                  1             73
## 2                  2            105
## 3                  3            137
## 4                  4             44
## 5                  5             68
## 6                  6             30
## 7                  7             21

Mapping accidents with implementation zones: 2014

##   ImplementationZone Accident_Index
## 1                  1            168
## 2                  2            275
## 3                  3            298
## 4                  4            109
## 5                  5            132
## 6                  6             89
## 7                  7             58

Mapping accidents with implementation zones: 2015

##   ImplementationZone Accident_Index
## 1                  1            155
## 2                  2            210
## 3                  3            273
## 4                  4             75
## 5                  5            144
## 6                  6             91
## 7                  7             43

Mapping accidents with implementation zones: 2016

##   ImplementationZone Accident_Index
## 1                  1             96
## 2                  2            120
## 3                  3            147
## 4                  4             48
## 5                  5             60
## 6                  6             48
## 7                  7             24

Mapping accidents with implementation zones: 2018

##   ImplementationZone Accident_Index
## 1                  1             88
## 2                  2            125
## 3                  3            160
## 4                  4             53
## 5                  5             68
## 6                  6             46
## 7                  7             30

Mapping accidents with implementation zones: 2019

##   ImplementationZone Accident_Index
## 1                  1             42
## 2                  2             68
## 3                  3             79
## 4                  4             33
## 5                  5             27
## 6                  6             18
## 7                  7             14

Output column: Implementation Zone

##   Accident_Index Speed_limit ImplementationZone
## 1  2013950000001          30                  1
## 2  2013950000002          30                  2
## 3  2013950000003          30                  2
## 4  2013950000007          30                  1
## 5  2013950000010          30                  4
## 6  2013950000058          20                  7

Total accidents per zone

s <- s_13 + s_14 + s_15 + s_16 + s_18 + s_19 
s$ImplementationZone <- s_13$ImplementationZone 
s
##   ImplementationZone Accident_Index
## 1                  1            622
## 2                  2            903
## 3                  3           1094
## 4                  4            362
## 5                  5            499
## 6                  6            322
## 7                  7            190

Control zone 1a:City center –> George St/Harbour, Aberdeen

## [1] 81

Control zone 1b:Rural west –> Tay Bridgehead & St Andrews

## [1] 60

Control zone 3:South central –> Dundee

## [1] 494

Control zone 4:North west -> Renfrew North, Renfrew South & Gallowhill, Paisley North West

## [1] 286

Control zone 5:West –> Glasgow Kelvin

## [1] 977

Control zone 6:South –> Paisley

## [1] 391

Updated dataset for Edinburgh

##   Accident_Index Speed_limit               LAYER Shape_Area
## 1        0000419          20  20mph main streets   17174685
## 2        0000519          20 20mph local streets    3385564
## 3        0000919          40 20mph local streets   29369816
## 4        0001019          20               30mph   17174685
## 5        0001219          40               40mph   15886220
## 6        0001419          30               30mph   15886220